How to: Join multiple tables in Microsoft Query.
Solution:
Select 'Joins...' from the 'Table' menu. Complete the 'Left', 'Operator', 'Right', 'Join Includes' and 'Joins in Query' fields. Click 'Add'. Repeat as needed for each new line, then click 'Close'.
1) Select the Microsoft Query 'Table' menu and select 'Joins...'. (The Joins dialog box appears.)
2) Select the table and field for the left side of the join line in the 'Left' list box.
3) Select the table and field for the right side of the join line in the 'Right' list box.
4) Select an operator from the 'Operator' list box to determine the linking relationship between the fields.
NOTE: The equal sign is the most common operator.
5) Select one of the 'Join Includes' radio buttons to determine what the join includes. NOTE: The second and third join types, called outer joins, can not be used if there are more than two tables on the table pane.
6) Click 'Add' to join the line to the table pane.
7) Repeat steps 2) through 6) for each join line to be created.
8) Click 'Close' to close the 'Joins' dialog box.
